Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 75166 |
| Missing cells | 82295 |
| Missing cells (%) | 3.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.1 MiB |
| Average record size in memory | 224.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 15 |
country has a high cardinality: 165 distinct values | High cardinality |
agent has 12310 (16.4%) missing values | Missing |
company has 69560 (92.5%) missing values | Missing |
previous_cancellations is highly skewed (γ1 = 29.14223836) | Skewed |
df_index has unique values | Unique |
lead_time has 5915 (7.9%) zeros | Zeros |
previous_cancellations has 74624 (99.3%) zeros | Zeros |
previous_bookings_not_canceled has 71746 (95.5%) zeros | Zeros |
booking_changes has 59920 (79.7%) zeros | Zeros |
days_in_waiting_list has 73827 (98.2%) zeros | Zeros |
total_of_special_requests has 36762 (48.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-05 02:48:23.103735 |
|---|---|
| Analysis finished | 2023-02-05 02:49:40.814839 |
| Duration | 1 minute and 17.71 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 75166 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66098.29473 |
| Minimum | 0 |
|---|---|
| Maximum | 119389 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13895.25 |
| Q1 | 29905.25 |
| median | 80541.5 |
| Q3 | 100580.75 |
| 95-th percentile | 115629.75 |
| Maximum | 119389 |
| Range | 119389 |
| Interquartile range (IQR) | 70675.5 |
Descriptive statistics
| Standard deviation | 37543.7521 |
|---|---|
| Coefficient of variation (CV) | 0.5679988002 |
| Kurtosis | -1.566288398 |
| Mean | 66098.29473 |
| Median Absolute Deviation (MAD) | 34285.5 |
| Skewness | -0.1500540579 |
| Sum | 4968344422 |
| Variance | 1409533322 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 94295 | 1 | < 0.1% |
| 94312 | 1 | < 0.1% |
| 94311 | 1 | < 0.1% |
| 94310 | 1 | < 0.1% |
| 94309 | 1 | < 0.1% |
| 94307 | 1 | < 0.1% |
| 94306 | 1 | < 0.1% |
| 94305 | 1 | < 0.1% |
| 94304 | 1 | < 0.1% |
| Other values (75156) | 75156 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 11 | 1 | |
| 12 | 1 |
| Value | Count | Frequency (%) |
| 119389 | 1 | |
| 119388 | 1 | |
| 119387 | 1 | |
| 119386 | 1 | |
| 119385 | 1 | |
| 119384 | 1 | |
| 119383 | 1 | |
| 119382 | 1 | |
| 119381 | 1 | |
| 119380 | 1 |
hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.76997579 |
| Min length | 10 |
Characters and Unicode
| Total characters | 809536 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 46228 | |
| Resort Hotel | 28938 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| hotel | 75166 | |
| city | 46228 | |
| resort | 28938 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| 75166 | ||
| H | 75166 | |
| l | 75166 | |
| C | 46228 | 5.7% |
| i | 46228 | 5.7% |
| y | 46228 | 5.7% |
| R | 28938 | 3.6% |
| Other values (2) | 57876 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 584038 | |
| Uppercase Letter | 150332 | 18.6% |
| Space Separator | 75166 | 9.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| l | 75166 | |
| i | 46228 | 7.9% |
| y | 46228 | 7.9% |
| s | 28938 | 5.0% |
| r | 28938 | 5.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 75166 | |
| C | 46228 | |
| R | 28938 | 19.2% |
Space Separator
| Value | Count | Frequency (%) |
| 75166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 734370 | |
| Common | 75166 | 9.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| H | 75166 | |
| l | 75166 | |
| C | 46228 | 6.3% |
| i | 46228 | 6.3% |
| y | 46228 | 6.3% |
| R | 28938 | 3.9% |
| s | 28938 | 3.9% |
Common
| Value | Count | Frequency (%) |
| 75166 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 809536 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 150332 | |
| o | 104104 | |
| e | 104104 | |
| 75166 | ||
| H | 75166 | |
| l | 75166 | |
| C | 46228 | 5.7% |
| i | 46228 | 5.7% |
| y | 46228 | 5.7% |
| R | 28938 | 3.6% |
| Other values (2) | 57876 | 7.1% |
| Distinct | 422 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.98468723 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 5915 |
| Zeros (%) | 7.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9 |
| median | 45 |
| Q3 | 124 |
| 95-th percentile | 269 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 115 |
Descriptive statistics
| Standard deviation | 91.10988782 |
|---|---|
| Coefficient of variation (CV) | 1.139091631 |
| Kurtosis | 2.292428857 |
| Mean | 79.98468723 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 1.526687435 |
| Sum | 6012129 |
| Variance | 8301.011659 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5915 | 7.9% |
| 1 | 3139 | 4.2% |
| 2 | 1856 | 2.5% |
| 3 | 1634 | 2.2% |
| 4 | 1539 | 2.0% |
| 5 | 1359 | 1.8% |
| 6 | 1243 | 1.7% |
| 7 | 1159 | 1.5% |
| 8 | 915 | 1.2% |
| 11 | 834 | 1.1% |
| Other values (412) | 55573 |
| Value | Count | Frequency (%) |
| 0 | 5915 | |
| 1 | 3139 | |
| 2 | 1856 | 2.5% |
| 3 | 1634 | 2.2% |
| 4 | 1539 | 2.0% |
| 5 | 1359 | 1.8% |
| 6 | 1243 | 1.7% |
| 7 | 1159 | 1.5% |
| 8 | 915 | 1.2% |
| 9 | 773 | 1.0% |
| Value | Count | Frequency (%) |
| 737 | 1 | < 0.1% |
| 709 | 1 | < 0.1% |
| 542 | 23 | |
| 532 | 1 | < 0.1% |
| 518 | 22 | |
| 504 | 21 | |
| 479 | 20 | |
| 478 | 2 | < 0.1% |
| 476 | 15 | |
| 468 | 30 |
arrival_date_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 300664 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 36370 | |
| 2017 | 24942 | |
| 2015 | 13854 | 18.4% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2016 | 36370 | |
| 2017 | 24942 | |
| 2015 | 13854 | 18.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 300664 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 300664 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 300664 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 75166 | |
| 0 | 75166 | |
| 1 | 75166 | |
| 6 | 36370 | |
| 7 | 24942 | 8.3% |
| 5 | 13854 | 4.6% |
arrival_date_month
Real number (ℝ≥0)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.526355001 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.153542756 |
|---|---|
| Coefficient of variation (CV) | 0.4832012288 |
| Kurtosis | -1.042706178 |
| Mean | 6.526355001 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.02586837604 |
| Sum | 490560 |
| Variance | 9.944831913 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 8 | 8638 | |
| 7 | 7919 | |
| 5 | 7114 | |
| 10 | 6914 | |
| 3 | 6645 | |
| 4 | 6565 | |
| 6 | 6404 | |
| 9 | 6392 | |
| 2 | 5372 | |
| 11 | 4672 | |
| Other values (2) | 8531 |
| Value | Count | Frequency (%) |
| 1 | 4122 | |
| 2 | 5372 | |
| 3 | 6645 | |
| 4 | 6565 | |
| 5 | 7114 | |
| 6 | 6404 | |
| 7 | 7919 | |
| 8 | 8638 | |
| 9 | 6392 | |
| 10 | 6914 |
| Value | Count | Frequency (%) |
| 12 | 4409 | |
| 11 | 4672 | |
| 10 | 6914 | |
| 9 | 6392 | |
| 8 | 8638 | |
| 7 | 7919 | |
| 6 | 6404 | |
| 5 | 7114 | |
| 4 | 6565 | |
| 3 | 6645 |
arrival_date_week_number
Real number (ℝ≥0)
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.08014262 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.90247758 |
|---|---|
| Coefficient of variation (CV) | 0.5133827311 |
| Kurtosis | -1.034346993 |
| Mean | 27.08014262 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.008567424333 |
| Sum | 2035506 |
| Variance | 193.2788827 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33 | 2075 | 2.8% |
| 34 | 1996 | 2.7% |
| 32 | 1879 | 2.5% |
| 30 | 1844 | 2.5% |
| 28 | 1804 | 2.4% |
| 21 | 1794 | 2.4% |
| 29 | 1747 | 2.3% |
| 31 | 1746 | 2.3% |
| 42 | 1681 | 2.2% |
| 27 | 1679 | 2.2% |
| Other values (43) | 56921 |
| Value | Count | Frequency (%) |
| 1 | 694 | |
| 2 | 823 | |
| 3 | 984 | |
| 4 | 981 | |
| 5 | 962 | |
| 6 | 1123 | |
| 7 | 1425 | |
| 8 | 1423 | |
| 9 | 1393 | |
| 10 | 1412 |
| Value | Count | Frequency (%) |
| 53 | 1172 | |
| 52 | 841 | |
| 51 | 687 | |
| 50 | 908 | |
| 49 | 1117 | |
| 48 | 1129 | |
| 47 | 1309 | |
| 46 | 985 | |
| 45 | 1180 | |
| 44 | 1527 |
arrival_date_day_of_month
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.83952851 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.776422332 |
|---|---|
| Coefficient of variation (CV) | 0.5540835591 |
| Kurtosis | -1.186816098 |
| Mean | 15.83952851 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.007459004258 |
| Sum | 1190594 |
| Variance | 77.02558894 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 25 | 2680 | 3.6% |
| 2 | 2670 | 3.6% |
| 18 | 2642 | 3.5% |
| 5 | 2638 | 3.5% |
| 19 | 2583 | 3.4% |
| 17 | 2569 | 3.4% |
| 6 | 2556 | 3.4% |
| 20 | 2549 | 3.4% |
| 9 | 2546 | 3.4% |
| 12 | 2541 | 3.4% |
| Other values (21) | 49192 |
| Value | Count | Frequency (%) |
| 1 | 2182 | |
| 2 | 2670 | |
| 3 | 2310 | |
| 4 | 2412 | |
| 5 | 2638 | |
| 6 | 2556 | |
| 7 | 2224 | |
| 8 | 2274 | |
| 9 | 2546 | |
| 10 | 2389 |
| Value | Count | Frequency (%) |
| 31 | 1448 | |
| 30 | 2390 | |
| 29 | 2318 | |
| 28 | 2435 | |
| 27 | 2387 | |
| 26 | 2521 | |
| 25 | 2680 | |
| 24 | 2494 | |
| 23 | 2440 | |
| 22 | 2255 |
adults
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 4051 |
| 0 | 294 |
| 4 | 46 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75166 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 54422 | |
| 1 | 16353 | 21.8% |
| 3 | 4051 | 5.4% |
| 0 | 294 | 0.4% |
| 4 | 46 | 0.1% |
children
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 3294 |
| 2.0 | 2111 |
| 3.0 | 59 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 225498 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 69702 | |
| 1.0 | 3294 | 4.4% |
| 2.0 | 2111 | 2.8% |
| 3.0 | 59 | 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0.0 | 69702 | |
| 1.0 | 3294 | 4.4% |
| 2.0 | 2111 | 2.8% |
| 3.0 | 59 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| . | 75166 | |
| 1 | 3294 | 1.5% |
| 2 | 2111 | 0.9% |
| 3 | 59 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 150332 | |
| Other Punctuation | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| 1 | 3294 | 2.2% |
| 2 | 2111 | 1.4% |
| 3 | 59 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 75166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 225498 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| . | 75166 | |
| 1 | 3294 | 1.5% |
| 2 | 2111 | 0.9% |
| 3 | 59 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 225498 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 144868 | |
| . | 75166 | |
| 1 | 3294 | 1.5% |
| 2 | 2111 | 0.9% |
| 3 | 59 | < 0.1% |
babies
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0 | |
|---|---|
| 1 | 735 |
| 2 | 13 |
| 10 | 1 |
| 9 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000013304 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75167 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 74416 | |
| 1 | 735 | 1.0% |
| 2 | 13 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 74416 | |
| 1 | 735 | 1.0% |
| 2 | 13 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75167 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75167 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75167 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 74417 | |
| 1 | 736 | 1.0% |
| 2 | 13 | < 0.1% |
| 9 | 1 | < 0.1% |
meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| BB | |
|---|---|
| HB | |
| SC | |
| Undefined | 883 |
| FB | 320 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.082231328 |
| Min length | 2 |
Characters and Unicode
| Total characters | 156513 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 57800 | |
| HB | 9479 | 12.6% |
| SC | 6684 | 8.9% |
| Undefined | 883 | 1.2% |
| FB | 320 | 0.4% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| bb | 57800 | |
| hb | 9479 | 12.6% |
| sc | 6684 | 8.9% |
| undefined | 883 | 1.2% |
| fb | 320 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.1% |
| S | 6684 | 4.3% |
| C | 6684 | 4.3% |
| n | 1766 | 1.1% |
| d | 1766 | 1.1% |
| e | 1766 | 1.1% |
| U | 883 | 0.6% |
| f | 883 | 0.6% |
| i | 883 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 149449 | |
| Lowercase Letter | 7064 | 4.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.3% |
| S | 6684 | 4.5% |
| C | 6684 | 4.5% |
| U | 883 | 0.6% |
| F | 320 | 0.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1766 | |
| d | 1766 | |
| e | 1766 | |
| f | 883 | |
| i | 883 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 156513 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.1% |
| S | 6684 | 4.3% |
| C | 6684 | 4.3% |
| n | 1766 | 1.1% |
| d | 1766 | 1.1% |
| e | 1766 | 1.1% |
| U | 883 | 0.6% |
| f | 883 | 0.6% |
| i | 883 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 156513 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 125399 | |
| H | 9479 | 6.1% |
| S | 6684 | 4.3% |
| C | 6684 | 4.3% |
| n | 1766 | 1.1% |
| d | 1766 | 1.1% |
| e | 1766 | 1.1% |
| U | 883 | 0.6% |
| f | 883 | 0.6% |
| i | 883 | 0.6% |
| Distinct | 165 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 421 |
| Missing (%) | 0.6% |
| Memory size | 587.4 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (160) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.986286708 |
| Min length | 2 |
Characters and Unicode
| Total characters | 223210 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | GBR |
| 4th row | GBR |
| 5th row | GBR |
Common Values
| Value | Count | Frequency (%) |
| PRT | 21071 | |
| GBR | 9676 | |
| FRA | 8481 | |
| ESP | 6391 | 8.5% |
| DEU | 6069 | 8.1% |
| IRL | 2543 | 3.4% |
| ITA | 2433 | 3.2% |
| BEL | 1868 | 2.5% |
| NLD | 1717 | 2.3% |
| USA | 1596 | 2.1% |
| Other values (155) | 12900 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| prt | 21071 | |
| gbr | 9676 | |
| fra | 8481 | |
| esp | 6391 | 8.6% |
| deu | 6069 | 8.1% |
| irl | 2543 | 3.4% |
| ita | 2433 | 3.3% |
| bel | 1868 | 2.5% |
| nld | 1717 | 2.3% |
| usa | 1596 | 2.1% |
| Other values (155) | 12900 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 223210 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 223210 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 223210 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 45992 | |
| P | 28483 | |
| T | 24966 | |
| E | 16818 | 7.5% |
| A | 16083 | 7.2% |
| B | 13222 | 5.9% |
| U | 10476 | 4.7% |
| S | 10385 | 4.7% |
| G | 10248 | 4.6% |
| F | 8917 | 4.0% |
| Other values (16) | 37620 |
market_segment
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Direct | |
| Groups | |
| Corporate | |
| Other values (2) | 831 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.144653168 |
| Min length | 6 |
Characters and Unicode
| Total characters | 687367 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | Online TA |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 35738 | |
| Offline TA/TO | 15908 | |
| Direct | 10672 | 14.2% |
| Groups | 7714 | 10.3% |
| Corporate | 4303 | 5.7% |
| Complementary | 646 | 0.9% |
| Aviation | 185 | 0.2% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| online | 35738 | |
| ta | 35738 | |
| offline | 15908 | |
| ta/to | 15908 | |
| direct | 10672 | 8.4% |
| groups | 7714 | 6.1% |
| corporate | 4303 | 3.4% |
| complementary | 646 | 0.5% |
| aviation | 185 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| O | 67554 | |
| T | 67554 | |
| i | 62688 | |
| l | 52292 | |
| A | 51831 | |
| 51646 | ||
| f | 31816 | 4.6% |
| r | 27638 | 4.0% |
| Other values (14) | 118220 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 409539 | |
| Uppercase Letter | 210274 | |
| Space Separator | 51646 | 7.5% |
| Other Punctuation | 15908 | 2.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| i | 62688 | |
| l | 52292 | |
| f | 31816 | 7.8% |
| r | 27638 | 6.7% |
| o | 17151 | 4.2% |
| t | 15806 | 3.9% |
| p | 12663 | 3.1% |
| c | 10672 | 2.6% |
| Other values (6) | 22685 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 67554 | |
| T | 67554 | |
| A | 51831 | |
| D | 10672 | 5.1% |
| G | 7714 | 3.7% |
| C | 4949 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 51646 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 15908 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 619813 | |
| Common | 67554 | 9.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| O | 67554 | |
| T | 67554 | |
| i | 62688 | |
| l | 52292 | |
| A | 51831 | |
| f | 31816 | 5.1% |
| r | 27638 | 4.5% |
| o | 17151 | 2.8% |
| Other values (12) | 85161 |
Common
| Value | Count | Frequency (%) |
| 51646 | ||
| / | 15908 | 23.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 687367 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 88215 | |
| e | 67913 | |
| O | 67554 | |
| T | 67554 | |
| i | 62688 | |
| l | 52292 | |
| A | 51831 | |
| 51646 | ||
| f | 31816 | 4.6% |
| r | 27638 | 4.0% |
| Other values (14) | 118220 |
distribution_channel
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 5203 |
| GDS | 156 |
| Undefined | 1 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.433600298 |
| Min length | 3 |
Characters and Unicode
| Total characters | 408422 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | TA/TO |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 57718 | |
| Direct | 12088 | 16.1% |
| Corporate | 5203 | 6.9% |
| GDS | 156 | 0.2% |
| Undefined | 1 | < 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| ta/to | 57718 | |
| direct | 12088 | 16.1% |
| corporate | 5203 | 6.9% |
| gds | 156 | 0.2% |
| undefined | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 115436 | |
| / | 57718 | |
| O | 57718 | |
| A | 57718 | |
| r | 22494 | 5.5% |
| e | 17293 | 4.2% |
| t | 17291 | 4.2% |
| D | 12244 | 3.0% |
| i | 12089 | 3.0% |
| c | 12088 | 3.0% |
| Other values (10) | 26333 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 248632 | |
| Lowercase Letter | 102072 | |
| Other Punctuation | 57718 | 14.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 22494 | |
| e | 17293 | |
| t | 17291 | |
| i | 12089 | |
| c | 12088 | |
| o | 10406 | |
| a | 5203 | 5.1% |
| p | 5203 | 5.1% |
| n | 2 | < 0.1% |
| d | 2 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 115436 | |
| O | 57718 | |
| A | 57718 | |
| D | 12244 | 4.9% |
| C | 5203 | 2.1% |
| G | 156 | 0.1% |
| S | 156 | 0.1% |
| U | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 57718 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 350704 | |
| Common | 57718 | 14.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 115436 | |
| O | 57718 | |
| A | 57718 | |
| r | 22494 | 6.4% |
| e | 17293 | 4.9% |
| t | 17291 | 4.9% |
| D | 12244 | 3.5% |
| i | 12089 | 3.4% |
| c | 12088 | 3.4% |
| o | 10406 | 3.0% |
| Other values (9) | 15927 | 4.5% |
Common
| Value | Count | Frequency (%) |
| / | 57718 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 408422 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 115436 | |
| / | 57718 | |
| O | 57718 | |
| A | 57718 | |
| r | 22494 | 5.5% |
| e | 17293 | 4.2% |
| t | 17291 | 4.2% |
| D | 12244 | 3.0% |
| i | 12089 | 3.0% |
| c | 12088 | 3.0% |
| Other values (10) | 26333 | 6.4% |
is_repeated_guest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0 | |
|---|---|
| 1 | 3258 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75166 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 71908 | |
| 1 | 3258 | 4.3% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01579171434 |
| Minimum | 0 |
|---|---|
| Maximum | 13 |
| Zeros | 74624 |
| Zeros (%) | 99.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2724214875 |
|---|---|
| Coefficient of variation (CV) | 17.25091283 |
| Kurtosis | 1043.553303 |
| Mean | 0.01579171434 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 29.14223836 |
| Sum | 1187 |
| Variance | 0.07421346684 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 0 | 74624 | |
| 1 | 337 | 0.4% |
| 2 | 78 | 0.1% |
| 3 | 45 | 0.1% |
| 11 | 25 | < 0.1% |
| 4 | 24 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 15 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 74624 | |
| 1 | 337 | 0.4% |
| 2 | 78 | 0.1% |
| 3 | 45 | 0.1% |
| 4 | 24 | < 0.1% |
| 5 | 17 | < 0.1% |
| 6 | 15 | < 0.1% |
| 11 | 25 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13 | 1 | < 0.1% |
| 11 | 25 | < 0.1% |
| 6 | 15 | < 0.1% |
| 5 | 17 | < 0.1% |
| 4 | 24 | < 0.1% |
| 3 | 45 | 0.1% |
| 2 | 78 | 0.1% |
| 1 | 337 | 0.4% |
| 0 | 74624 |
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.20297741 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 71746 |
| Zeros (%) | 95.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.81071327 |
|---|---|
| Coefficient of variation (CV) | 8.920762514 |
| Kurtosis | 534.2063652 |
| Mean | 0.20297741 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.60351104 |
| Sum | 15257 |
| Variance | 3.278682547 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 71746 | |
| 1 | 1463 | 1.9% |
| 2 | 548 | 0.7% |
| 3 | 316 | 0.4% |
| 4 | 217 | 0.3% |
| 5 | 170 | 0.2% |
| 6 | 112 | 0.1% |
| 7 | 83 | 0.1% |
| 8 | 67 | 0.1% |
| 9 | 60 | 0.1% |
| Other values (63) | 384 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 71746 | |
| 1 | 1463 | 1.9% |
| 2 | 548 | 0.7% |
| 3 | 316 | 0.4% |
| 4 | 217 | 0.3% |
| 5 | 170 | 0.2% |
| 6 | 112 | 0.1% |
| 7 | 83 | 0.1% |
| 8 | 67 | 0.1% |
| 9 | 60 | 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
reserved_room_type
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| A | |
|---|---|
| D | |
| E | 4621 |
| F | 2017 |
| G | 1331 |
| Other values (4) | 1734 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| a | 52364 | |
| d | 13099 | 17.4% |
| e | 4621 | 6.1% |
| f | 2017 | 2.7% |
| g | 1331 | 1.8% |
| b | 750 | 1.0% |
| c | 624 | 0.8% |
| h | 356 | 0.5% |
| l | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 75166 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 75166 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 52364 | |
| D | 13099 | 17.4% |
| E | 4621 | 6.1% |
| F | 2017 | 2.7% |
| G | 1331 | 1.8% |
| B | 750 | 1.0% |
| C | 624 | 0.8% |
| H | 356 | 0.5% |
| L | 4 | < 0.1% |
assigned_room_type
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 2824 |
| C | 1929 |
| Other values (5) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| a | 41105 | |
| d | 18960 | |
| e | 5838 | 7.8% |
| f | 2824 | 3.8% |
| c | 1929 | 2.6% |
| g | 1773 | 2.4% |
| b | 1651 | 2.2% |
| h | 461 | 0.6% |
| i | 358 | 0.5% |
| k | 267 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 75166 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 75166 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 41105 | |
| D | 18960 | |
| E | 5838 | 7.8% |
| F | 2824 | 3.8% |
| C | 1929 | 2.6% |
| G | 1773 | 2.4% |
| B | 1651 | 2.2% |
| H | 461 | 0.6% |
| I | 358 | 0.5% |
| K | 267 | 0.4% |
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2933663287 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 59920 |
| Zeros (%) | 79.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7362788719 |
|---|---|
| Coefficient of variation (CV) | 2.5097593 |
| Kurtosis | 66.61474151 |
| Mean | 0.2933663287 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.397378632 |
| Sum | 22050 |
| Variance | 0.5421065772 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 0 | 59920 | |
| 1 | 10893 | 14.5% |
| 2 | 3039 | 4.0% |
| 3 | 783 | 1.0% |
| 4 | 309 | 0.4% |
| 5 | 98 | 0.1% |
| 6 | 45 | 0.1% |
| 7 | 28 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 7 | < 0.1% |
| Other values (11) | 27 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 59920 | |
| 1 | 10893 | 14.5% |
| 2 | 3039 | 4.0% |
| 3 | 783 | 1.0% |
| 4 | 309 | 0.4% |
| 5 | 98 | 0.1% |
| 6 | 45 | 0.1% |
| 7 | 28 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 1 | < 0.1% |
| 15 | 3 | |
| 14 | 4 | |
| 13 | 5 | |
| 12 | 2 | < 0.1% |
| 11 | 2 | < 0.1% |
deposit_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| No Deposit | |
|---|---|
| Refundable | 126 |
| Non Refund | 93 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 751660 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 74947 | |
| Refundable | 126 | 0.2% |
| Non Refund | 93 | 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| no | 74947 | |
| deposit | 74947 | |
| refundable | 126 | 0.1% |
| non | 93 | 0.1% |
| refund | 93 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| N | 75040 | |
| 75040 | ||
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| D | 74947 | |
| n | 312 | < 0.1% |
| Other values (7) | 1254 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 526414 | |
| Uppercase Letter | 150206 | 20.0% |
| Space Separator | 75040 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| n | 312 | 0.1% |
| f | 219 | < 0.1% |
| u | 219 | < 0.1% |
| d | 219 | < 0.1% |
| Other values (3) | 378 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 75040 | |
| D | 74947 | |
| R | 219 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 75040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 676620 | |
| Common | 75040 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| N | 75040 | |
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| D | 74947 | |
| n | 312 | < 0.1% |
| R | 219 | < 0.1% |
| Other values (6) | 1035 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 75040 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 751660 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 149987 | |
| e | 75292 | |
| N | 75040 | |
| 75040 | ||
| s | 74947 | |
| i | 74947 | |
| t | 74947 | |
| p | 74947 | |
| D | 74947 | |
| n | 312 | < 0.1% |
| Other values (7) | 1254 | 0.2% |
| Distinct | 314 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 12310 |
| Missing (%) | 16.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.0557942 |
| Minimum | 1 |
|---|---|
| Maximum | 535 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 14 |
| Q3 | 240 |
| 95-th percentile | 273 |
| Maximum | 535 |
| Range | 534 |
| Interquartile range (IQR) | 231 |
Descriptive statistics
| Standard deviation | 113.947162 |
|---|---|
| Coefficient of variation (CV) | 1.211484768 |
| Kurtosis | -0.2374568407 |
| Mean | 94.0557942 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.9779323318 |
| Sum | 5911971 |
| Variance | 12983.95573 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9 | 18697 | |
| 240 | 8438 | |
| 7 | 3065 | 4.1% |
| 14 | 2988 | 4.0% |
| 250 | 2357 | 3.1% |
| 6 | 2265 | 3.0% |
| 1 | 1911 | 2.5% |
| 28 | 1556 | 2.1% |
| 241 | 1485 | 2.0% |
| 8 | 1087 | 1.4% |
| Other values (304) | 19007 | |
| (Missing) | 12310 |
| Value | Count | Frequency (%) |
| 1 | 1911 | 2.5% |
| 2 | 128 | 0.2% |
| 3 | 565 | 0.8% |
| 4 | 16 | < 0.1% |
| 5 | 181 | 0.2% |
| 6 | 2265 | 3.0% |
| 7 | 3065 | 4.1% |
| 8 | 1087 | 1.4% |
| 9 | 18697 | |
| 10 | 196 | 0.3% |
| Value | Count | Frequency (%) |
| 535 | 3 | < 0.1% |
| 531 | 22 | |
| 527 | 35 | |
| 526 | 9 | < 0.1% |
| 510 | 2 | < 0.1% |
| 509 | 8 | < 0.1% |
| 508 | 6 | < 0.1% |
| 502 | 24 | |
| 497 | 1 | < 0.1% |
| 495 | 7 | < 0.1% |
| Distinct | 331 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 69560 |
| Missing (%) | 92.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 190.5192651 |
| Minimum | 6 |
|---|---|
| Maximum | 541 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 51 |
| median | 183 |
| Q3 | 270 |
| 95-th percentile | 437 |
| Maximum | 541 |
| Range | 535 |
| Interquartile range (IQR) | 219 |
Descriptive statistics
| Standard deviation | 132.3492861 |
|---|---|
| Coefficient of variation (CV) | 0.6946766566 |
| Kurtosis | -0.4896916298 |
| Mean | 190.5192651 |
| Median Absolute Deviation (MAD) | 107 |
| Skewness | 0.5873683742 |
| Sum | 1068051 |
| Variance | 17516.33353 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40 | 850 | 1.1% |
| 223 | 665 | 0.9% |
| 45 | 222 | 0.3% |
| 153 | 167 | 0.2% |
| 219 | 132 | 0.2% |
| 174 | 128 | 0.2% |
| 154 | 128 | 0.2% |
| 281 | 121 | 0.2% |
| 233 | 103 | 0.1% |
| 405 | 101 | 0.1% |
| Other values (321) | 2989 | 4.0% |
| (Missing) | 69560 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 34 | |
| 10 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 12 | 14 | < 0.1% |
| 14 | 8 | < 0.1% |
| 16 | 5 | < 0.1% |
| 18 | 1 | < 0.1% |
| 20 | 39 |
| Value | Count | Frequency (%) |
| 541 | 1 | < 0.1% |
| 539 | 2 | < 0.1% |
| 534 | 2 | < 0.1% |
| 530 | 4 | < 0.1% |
| 528 | 2 | < 0.1% |
| 525 | 15 | |
| 523 | 19 | |
| 521 | 6 | < 0.1% |
| 520 | 1 | < 0.1% |
| 518 | 2 | < 0.1% |
| Distinct | 98 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.589867759 |
| Minimum | 0 |
|---|---|
| Maximum | 379 |
| Zeros | 73827 |
| Zeros (%) | 98.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 379 |
| Range | 379 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.78487546 |
|---|---|
| Coefficient of variation (CV) | 9.299437246 |
| Kurtosis | 192.7357548 |
| Mean | 1.589867759 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.59756589 |
| Sum | 119504 |
| Variance | 218.5925423 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 73827 | |
| 58 | 164 | 0.2% |
| 87 | 76 | 0.1% |
| 122 | 53 | 0.1% |
| 63 | 51 | 0.1% |
| 38 | 47 | 0.1% |
| 176 | 39 | 0.1% |
| 77 | 37 | < 0.1% |
| 223 | 36 | < 0.1% |
| 65 | 35 | < 0.1% |
| Other values (88) | 801 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 73827 | |
| 1 | 9 | < 0.1% |
| 2 | 4 | < 0.1% |
| 4 | 17 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 16 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 379 | 6 | < 0.1% |
| 330 | 14 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 29 | |
| 224 | 4 | < 0.1% |
| 223 | 36 | |
| 215 | 8 | < 0.1% |
| 207 | 10 | < 0.1% |
| 187 | 22 | |
| 185 | 2 | < 0.1% |
customer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 2814 |
| Group | 518 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.43048719 |
| Min length | 5 |
Characters and Unicode
| Total characters | 784018 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 53099 | |
| Transient-Party | 18735 | 24.9% |
| Contract | 2814 | 3.7% |
| Group | 518 | 0.7% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| transient | 53099 | |
| transient-party | 18735 | 24.9% |
| contract | 2814 | 3.7% |
| group | 518 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| T | 71834 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.4% |
| - | 18735 | 2.4% |
| Other values (7) | 29249 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 671382 | |
| Uppercase Letter | 93901 | 12.0% |
| Dash Punctuation | 18735 | 2.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.8% |
| o | 3332 | 0.5% |
| c | 2814 | 0.4% |
| Other values (2) | 1036 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 71834 | |
| P | 18735 | 20.0% |
| C | 2814 | 3.0% |
| G | 518 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 18735 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 765283 | |
| Common | 18735 | 2.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| T | 71834 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.4% |
| P | 18735 | 2.4% |
| Other values (6) | 10514 | 1.4% |
Common
| Value | Count | Frequency (%) |
| - | 18735 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 784018 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 146482 | |
| t | 96197 | |
| r | 93901 | |
| a | 93383 | |
| T | 71834 | |
| s | 71834 | |
| i | 71834 | |
| e | 71834 | |
| y | 18735 | 2.4% |
| - | 18735 | 2.4% |
| Other values (7) | 29249 | 3.7% |
required_car_parking_spaces
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 587.4 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | 28 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 75166 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75166 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 75166 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 75166 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 67750 | |
| 1 | 7383 | 9.8% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7140595482 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 36762 |
| Zeros (%) | 48.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.833886853 |
|---|---|
| Coefficient of variation (CV) | 1.167811361 |
| Kurtosis | 0.8969141785 |
| Mean | 0.7140595482 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.077975244 |
| Sum | 53673 |
| Variance | 0.6953672836 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 36762 | |
| 1 | 25908 | |
| 2 | 10103 | 13.4% |
| 3 | 2051 | 2.7% |
| 4 | 304 | 0.4% |
| 5 | 38 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 36762 | |
| 1 | 25908 | |
| 2 | 10103 | 13.4% |
| 3 | 2051 | 2.7% |
| 4 | 304 | 0.4% |
| 5 | 38 | 0.1% |
| Value | Count | Frequency (%) |
| 5 | 38 | 0.1% |
| 4 | 304 | 0.4% |
| 3 | 2051 | 2.7% |
| 2 | 10103 | 13.4% |
| 1 | 25908 | |
| 0 | 36762 |
stays_total
Real number (ℝ≥0)
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.393023441 |
| Minimum | 0 |
|---|---|
| Maximum | 69 |
| Zeros | 680 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 587.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 69 |
| Range | 69 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.577670726 |
|---|---|
| Coefficient of variation (CV) | 0.7596972936 |
| Kurtosis | 30.80112497 |
| Mean | 3.393023441 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.19584567 |
| Sum | 255040 |
| Variance | 6.64438637 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 1 | 15749 | |
| 3 | 15725 | |
| 2 | 15480 | |
| 4 | 11025 | |
| 7 | 5686 | 7.6% |
| 5 | 5121 | 6.8% |
| 6 | 2322 | 3.1% |
| 10 | 783 | 1.0% |
| 8 | 720 | 1.0% |
| 0 | 680 | 0.9% |
| Other values (33) | 1875 | 2.5% |
| Value | Count | Frequency (%) |
| 0 | 680 | 0.9% |
| 1 | 15749 | |
| 2 | 15480 | |
| 3 | 15725 | |
| 4 | 11025 | |
| 5 | 5121 | 6.8% |
| 6 | 2322 | 3.1% |
| 7 | 5686 | 7.6% |
| 8 | 720 | 1.0% |
| 9 | 528 | 0.7% |
| Value | Count | Frequency (%) |
| 69 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 57 | 1 | < 0.1% |
| 56 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 46 | 1 | < 0.1% |
| 45 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42 | 3 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.
First rows
| df_index | hotel | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | required_car_parking_spaces | total_of_special_requests | stays_total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | Resort Hotel | 342 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 3.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 0 |
| 1 | 1 | Resort Hotel | 737 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 4.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 0 |
| 2 | 2 | Resort Hotel | 7 | 2015 | 7 | 27 | 1 | 1 | 0.0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | C | 0.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 1 |
| 3 | 3 | Resort Hotel | 13 | 2015 | 7 | 27 | 1 | 1 | 0.0 | 0 | BB | GBR | Corporate | Corporate | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 304.0 | nan | 0 | Transient | 0 | 0 | 1 |
| 4 | 4 | Resort Hotel | 14 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 1 | 2 |
| 5 | 5 | Resort Hotel | 14 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 1 | 2 |
| 6 | 6 | Resort Hotel | 0 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0.0 | No Deposit | nan | nan | 0 | Transient | 0 | 0 | 2 |
| 7 | 7 | Resort Hotel | 9 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | FB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0.0 | No Deposit | 303.0 | nan | 0 | Transient | 0 | 1 | 2 |
| 8 | 11 | Resort Hotel | 35 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | HB | PRT | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 0 | 4 |
| 9 | 12 | Resort Hotel | 68 | 2015 | 7 | 27 | 1 | 2 | 0.0 | 0 | BB | USA | Online TA | TA/TO | 0 | 0 | 0 | D | E | 0.0 | No Deposit | 240.0 | nan | 0 | Transient | 0 | 3 | 4 |
Last rows
| df_index | hotel | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | required_car_parking_spaces | total_of_special_requests | stays_total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75156 | 119380 | City Hotel | 44 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | SC | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 1 | 4 |
| 75157 | 119381 | City Hotel | 188 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | DEU | Direct | Direct | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 14.0 | nan | 0 | Transient | 0 | 0 | 5 |
| 75158 | 119382 | City Hotel | 135 | 2017 | 8 | 35 | 30 | 3 | 0.0 | 0 | BB | JPN | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0.0 | No Deposit | 7.0 | nan | 0 | Transient | 0 | 0 | 6 |
| 75159 | 119383 | City Hotel | 164 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 42.0 | nan | 0 | Transient | 0 | 0 | 6 |
| 75160 | 119384 | City Hotel | 21 | 2017 | 8 | 35 | 30 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 394.0 | nan | 0 | Transient | 0 | 2 | 7 |
| 75161 | 119385 | City Hotel | 23 | 2017 | 8 | 35 | 30 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 394.0 | nan | 0 | Transient | 0 | 0 | 7 |
| 75162 | 119386 | City Hotel | 102 | 2017 | 8 | 35 | 31 | 3 | 0.0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 2 | 7 |
| 75163 | 119387 | City Hotel | 34 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 4 | 7 |
| 75164 | 119388 | City Hotel | 109 | 2017 | 8 | 35 | 31 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 89.0 | nan | 0 | Transient | 0 | 0 | 7 |
| 75165 | 119389 | City Hotel | 205 | 2017 | 8 | 35 | 29 | 2 | 0.0 | 0 | HB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0.0 | No Deposit | 9.0 | nan | 0 | Transient | 0 | 2 | 9 |